create external table jms_ods.yl_nwm_cost_config_detail
(
    id          string
    ,cost_id     string comment '主表id'
    ,first_code  string comment '一级费用编码'
    ,first_name  string comment '一级费用名称'
    ,second_code string comment '二级费用编码'
    ,second_name string comment '二级费用名称'
    ,cost_unit   string comment '算费维度'
    ,freight     string comment '金额'
    ,remark      string comment '备注'
    ,char_field1 string comment '文本字段1'
    ,char_field2 string comment '文本字段2'
    ,char_field3 string comment '文本字段3'
    ,char_field4 string comment '文本字段4'
    ,char_field5 string comment '文本字段5'
)comment '网点成本配置明细'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_ods.db/external/yl_nwm_cost_config_detail'
tblproperties (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);
